{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Instructions","Level 1 Compensatory Time"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":34,"n_cols":6,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,0,2,10]]}
[{"$error":"#VALUE!"}]
[]
[]
[]
[null,"How to enter information"]
[null,null,"Type into cells shaded light gray."]
[null,null,"Press the TAB key on the keyboard to register each entry and advance to the next cell."]
[null,null,null,"Or, use the mouse to move the cursor from cell to cell."]
[null,null,"You must press TAB, click to another cell, or press ENTER or RETURN on the"]
[null,null,null,"keyboard to register each cell entry.  If you do not do this, it will appear that the"]
[null,null,null,"screen has frozen while Excel waits patiently for you to let it know you have finished an entry."]
[]
[null,"Work Week and FTE"]
[null,null,"Select Either 40 hrs/week or 37.5 hrs/week from the dropdown."]
[null,null,"A number must be entered into the FTE field between .25 and 1.00."]
[]
[null,"Time Format"]
[null,null,"Enter time by typing the hours and minutes followed by  am or pm."]
[null,null,"There must be one space between the time and am or pm."]
[]
[null,null,"Examples:"]
[]
[null,null,"Typed into cell",null,"Result","Notes:"]
[null,null,"8 a","=","08:00:00","Typing a or p is the same as typing am or pm."]
[null,null,"8 am","=","08:00:00","It is not necessary to type :00 for times on the hour."]
[null,null,"8:00 am","=","08:00:00","AM and PM are not case senstive"]
[null,null,"8 A.M.","=","Error","Do not put periods into the abbreviations for am or pm"]
[null,null,"8am","=","Error","There must be a space between the digit 8 and the letter a"]
[null,null,"8:10 AM","=","Error","Times must be on the hour, or 15 minute increments thereof ."]
[null,null,"8","=","Error","Must specify AM or PM."]
[]
[null,"Lunch"]
[null,null,"If a shift is longer than 6 hours, at least 1/2 hour must be taken for lunch."]
[null,null,"Lunch does not have to be taken if a shift is 6 hours or less."]

{"sheet":"Level 1 Compensatory Time","index":1,"n_rows":54,"n_cols":11,"rows_kept":54,"cut":false,"hidden":false,"merged":[[11,1,11,2],[28,5,29,10],[31,8,31,10],[48,1,48,5],[48,8,48,9],[53,2,53,4],[53,5,53,6],[53,7,53,10],[1,1,3,3],[1,6,3,10],[5,1,10,10],[17,1,17,3],[13,1,13,3],[13,6,13,7],[15,1,15,2],[15,8,15,10],[15,4,15,6],[31,1,31,6],[32,3,32,4],[20,1,20,3],[21,2,21,3]]}
[]
[null,{"$error":"#VALUE!"},null,null,null,null,"Level 1 FLSA Exempt \nEmergency Response Compensatory Time"]
[]
[]
[]
[null,"This form is only for employees exempt from FLSA, designated officially as ‘Level 1’, directed to report to campus during an emergency when classes and activites have been cancelled. These employees are eligible to earn compensatory time on an hour for hour basis, for each hour of work beyond their normal daily working hours as part of the university’s emergency response.\n\nThis compensatory time is available for use as a leave accrual, has no cash value and expires at the end of the fiscal year following the fiscal year in which it was earned."]
[]
[]
[]
[]
[]
[null,"EMPLOYEE INFORMATION:"]
[null,"LAST NAME",null,null,null,null,"FIRST NAME",null,null,"MI"]
[]
[null,"PERSON NUMBER",null,null,"PHONE NUMBER",null,null,null,"EMAIL"]
[]
[null,"DEPARTMENT NAME",null,null,null,"FTE",null,"WORKWEEK"]
[]
[]
[null,null,null,null,null,"INSTRUCTIONS:"]
[null,"Regular Schedule ",null,null,null,"1. Employee fill in gray boxes to complete form."]
[null,"Day of Week","Scheduled Hours",null,null,"2. Goes to File > Save as \"Your Name Level 1 Compensatory Time.\""]
[null,null,"Time In","Time Out",null,"3. Emails to their supervisor for review and approval."]
[null,"Thursday",null,null,null,"4. Supervisor to discuss any changes with their employee."]
[null,"Friday",null,null,null,"5. Once timesheet is accurate, supervisor clicks attestation checkbox."]
[null,"Saturday",null,null,null,"6. Supervisor inputs their name and email."]
[null,"Sunday",null,null,null,"7. Supervisor saves file."]
[null,"Monday",null,null,null,"8. Supervisor clicks 'SUBMIT'."]
[null,"Tuesday",null,null,null,"HR will review your submission, any compensatory time earned will be noted in the 'Additional Comments' section on your monthly timesheet. "]
[null,"Wednesday"]
[]
[null,"Regular Time ",null,null,null,null,null,null,"Compensatory Time"]
[null,"Date","Time In","Lunch",null,"Time Out",null,null,"Time In","Time Out"]
[null,null,null,"Out","In",null,"Total",null,null,null,"Total"]
[null,"Start Date","","","",null,"",null,"","",""]
[null,null,null,null,null,null,{"$f":"((F36-E36+D36-C36)/0.3125*7.5)","v":0},null,null,null,{"$f":"((J36-I36)/0.3125*7.5)","v":0}]
[null,null,null,null,null,null,null,null,null,null,""]
[null,{"$f":"B36+1","v":"1900-01-01"},null,null,null,null,{"$f":"((F38-E38+D38-C38)/0.3125*7.5)","v":0},null,null,null,{"$f":"((J38-I38)/0.3125*7.5)","v":0}]
[null,null,null,null,null,null,null,null,null,null,""]
[null,{"$f":"B38+1","v":"1900-01-02"},null,null,null,null,0,null,null,null,{"$f":"((J40-I40)/0.3125*7.5)","v":0}]
[null,null,null,null,null,null,null,null,null,null,""]
[null,{"$f":"B40+1","v":"1900-01-03"},null,null,null,null,0,null,null,null,{"$f":"((J42-I42)/0.3125*7.5)","v":0}]
[null,null,null,null,null,null,null,null,null,null,""]
[null,{"$f":"B42+1","v":"1900-01-04"},null,null,null,null,0,null,null,null,{"$f":"((J44-I44)/0.3125*7.5)","v":0}]
[]
[null,{"$f":"B44+1","v":"1900-01-05"},null,null,null,null,0,null,null,null,{"$f":"((J46-I46)/0.3125*7.5)","v":0}]
[]
[null,{"$f":"B46+1","v":"1900-01-06"},null,null,null,null,0,null,null,null,{"$f":"((J48-I48)/0.3125*7.5)","v":0}]
[null,"Total ",null,null,null,null,{"$f":"SUM(G36:G48)","v":0},null,"Total ",null,{"$f":"SUM(K36:K48)","v":0}]
[]
[]
[]
[]
[null,"Supervisor Name",null,null,null,"Supervisor Email"]